if exists (select * from dbo.sysobjects where name='sp_UpdateSinhVien')
begin
	Drop Proc sp_UpdateSinhVien
end
go
create proc sp_UpdateSinhVien
@ID INT,
@HOTEN varchar(40),
@NGAYSINH datetime,
@EMAIL varchar(40),
@DIENTHOAI INT,
@TENLOP VARCHAR(40),
@MA_TV INT,
@MA_LOP INT,
@GIOITINH VARCHAR(40),
@DIACHI VARCHAR(40),
@CMND INT
as 
begin 
update SINHVIEN set  HOTEN=@HOTEN, NGAYSINH=@NGAYSINH, EMAIL=@EMAIL, CMND=@CMND, DIENTHOAI=@DIENTHOAI, TENLOP=@TENLOP, MA_TV=@MA_TV, MA_LOP=@MA_LOP,
GIOITINH=@GIOITINH, DIACHI=@DIACHI, 
where ID=@ID
end